if exist mysql

After I deleted the original mysql4.0 file in s9, I installed a new mysql5.0 file. During the startup process, I reported an error and failed to start the file. I checked the old post in the group and did not provide a specific description. After I

Records in error log: [ERROR] Fatal Error:can ' t open and Lock Privilege tables:table ' mysql.host ' doesn ' t exist From the post, only people look, no one replied, see this situation can only solve their own problems, their hands and clothing,

Records in the error log: [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql. host' doesn' t exist I posted a post. I only saw it, but no one replied. I can only solve the problem by myself. Can I help myself... You don't have

**************************************** ****************** The first part is to build a multi-mysql service on a server. **************************************** ****************** I. xuyan There is a mysqld_multi command in Mysql that can be used

-- Add users and groups [root @ zlmlocal] groupadd [root @ zlmlocal] useradd-gmysql-ssbinnologin-doptmsyqlmysql -- create a directory [root @ zlmlocal] mkdirdatamysqlmysql_3306 {data, l -- Add users and groups[Root @ zlm local] # groupadd [Root @

Insert when the MySQL record does not exist In MySQL, inserting a record is very simple, but in some special applications, before inserting a record, you need to check whether the record already exists. The insert operation is performed only when

Run multiple MySQL services on the same machine Run multiple MySQL services on the same machine **************************************** ****************** The first part is to build a multi-mysql service on a server. *****************************

MySQL builds a series of multiple instances. The so-called multi-instance is to build and run multiple MySQL instances on one server. each instance uses different service ports and listens through different sockets. physically, each instance has an

Insert when MySQL record does not existIn MySQL, inserting (insert) A record is very simple, but some special applications, before inserting the record, need to check whether this record already exists, only if the record does not exist, the insert

Insert when the mysql record does not existIn MySQL, inserting a record is very simple, but in some special applications, before inserting a record, you need to check whether the record already exists. The insert operation is performed only when the